[ic] postgresql database

Steve Graham icdev at mrlock.com
Mon Aug 18 16:54:16 UTC 2008


> I am using postgresql. I need to change my encoding on the database. It
> is setup as SQL_ACSll. And I need to change it to UTF8. If I recreate
> the database with UTF8 and then dump the data back to it will IC
> reconnect to that database with no problems.
>

Hello,

Sorry if this is an ignorant question - not real familiar with UTF8 and its 
features,
but I did a quick look at my MySQL database structures, and most of my 
settings are UTF8

 Variable   Session value   Global value
character set client  utf8  utf8
character set connection  utf8  utf8
character set database  utf8  utf8
character set results  utf8  utf8
character set server  utf8  utf8
character set system  utf8  utf8
character sets dir  /usr/share/mysql/charsets/  /usr/share/mysql/charsets/
collation connection  utf8_general_ci  utf8_general_ci
collation database  utf8_general_ci  utf8_general_ci
collation server  utf8_general_ci  utf8_general_ci

I have been using this setup for some time now, with MySql (4.1.x), and IC 
5.4 and not having any issues.

What changes are causing the problems with using UTF and the database 
server, or is this just a html encoding problem?

Steve 




More information about the interchange-users mailing list