Page 1 of 1

MySQL 4.1 embedded adding charset problem

Posted: 08.07.2007, 13:54
by InfaNT
I have mysql 4.1 installed.
In db exist tables with charset cp1251

Execute SHOW CHARSET on my server:

Code: Select all

 Charset                 Description  "Default collation Maxlen
    big5    Big5 Traditional Chinese     big5_chinese_ci      2
...
  cp1251            Windows Cyrillic   cp1251_general_ci      1
....
   cp932   SJIS for Windows Japanese   cp932_japanese_ci      2
zeos 6.6.1 - beta

I copy folder D:\Program Files\MySQL\MySQL Server 4.1\share to \zeos\examples\embedded\share
And copy my db files to \zeos\examples\embedded\data

Compile&Run embedded example
Execute SHOW CHARSET on embedded server, but not found cp1251 codepage in list

When trying open table created with cp1251 charset:
SQL Error: unknown collation '#51' in table 'test' definition

Question:
How add cp1251 charset to embedded server?

Thanks

Posted: 09.07.2007, 07:44
by InfaNT
Problem solved.

In Connection.Properties all values of server arguments must be FULL path.

Example:

Before (not worked):

Code: Select all

ServerArgument3=--character-sets-dir=./share/charsets
After (worked):

Code: Select all

ServerArgument3=--character-sets-dir=D:\Delphi7\cp\zeos\examples\embedded\share\charsets