AnyOne Who Knows How to Use CODEPAGE_1253MS-Windows Greek codepage 1253. with MariaDB

[Dionisis Divaris]

Hello to all
Anyone who knows how to use CODEPAGE_1253 (MS-Windows Greek codepage 1253) with MariaDB with an example (database and table creation examples if is possible) please.

[jfgimenez]

Dionisis,
> Anyone who knows how to use CODEPAGE_1253 (MS-Windows Greek
> codepage 1253) with MariaDB with an example (database and
> table creation examples if is possible) please.
The easyest way is to configure both, server and client, to use the
right codepage. Another way (and from my POV the best way) is to
configure the server to use UTF-8, and run "SET NAMES 'greek'" (ISO
8859-7 Greek) just upon connection.
This last way is what I'm using in my programs. I configure the server
in UTF-8, and to avoid translating every string into UTF-8 from my
program, I just call ::oDB:Execute( "SET NAMES 'latin1'" ) when
connected ('latin1' is the codepage I need).
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info

[Dionisis Divaris]

Many thanks Jose
I will give a try. Another question on database and table creataion
may i use the following for your solution?

" CHARACTER SET 'greek'; " +;
" COLLATE 'greek_general_ci';"

And aupon what execute the "SET NAME "xxxxx"" command, on connection, on database or on table. Sorry for my silly questions but since now i used only dbf/cdx combination. This is first attemp on MariaDB/MySql Databases Schemas. Any small sample would be apreciated. So please helpme on this. If i entered international (English Character) no problem, the problem comes when entering greek characters, i took the message:
#1: MariaDB:INSERT INTO Contacts( name ) VALUES( 'ΔΣΔΣΣ' )
Incorrect string value: 'xC4xD3xC4xD3xD3' for column 'name' at row 1 [# 1366]

[jfgimenez]

Dionisis,
> I will give a try. Another question on database and table
> creataion
> may i use the following:
>
> " CHARACTER SET 'greek'; " +;
> " COLLATE 'greek_general_ci';"
>
> for your solution?
Yes, I think so. BTW, I've just checked my MariaDB installation for
"SHOW COLLATION", and for greek there are only 2 collations:
"greek_general_ci" and "greek_bin", and both are for charset "greek",
not "utf-8", so I suppose you have to use "greek" charset in your DB.
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info

[Dionisis Divaris]

Hello again Jose
I gave up MySql/MariaDB are not for me (diden't like greeks) still the same message with all combinations. I return to the known dbf/cdx combination.
Thanks for your help.

[jfgimenez]

Dionisis,
> I gave up MySql/MariaDB are not for me (diden't like greeks)
> still the same message with all combinations. I
> return to the known dbf/cdx combination.
Well, I noticed that 'greek' support is rather poor in MariaDB. Since
unicode covers all character sets, it'd be desirable to configure the
server to use unicode, while clients use their own charsets (i.e.
latin1, which is my case). But it seems it's not possible for greek. It
seems that the server should be also configured to use greek.
BTW, if you've decided to keep using dbf, give a try to SQLite. SQLite
always uses utf-8 internally, but you can store strings in any charset.
And it's a very good replace for dbf.
Regards,
Jose F. Gimenez
http://www.xailer.com
http://www.xailer.info