[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