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.
In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
AnyOne Who Knows How to Use CODEPAGE_1253MS-Windows Greek codepage 1253. with MariaDB
- Dionisis Divaris
- Mensajes: 485
- Registrado: Jue Jul 12, 2007 8:48 pm
- Ubicación: Athens Greece
AnyOne Who Knows How to Use CODEPAGE_1253MS-Windows Greek codepage 1253. with MariaDB
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
> 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
- Mensajes: 485
- Registrado: Jue Jul 12, 2007 8:48 pm
- Ubicación: Athens Greece
AnyOne Who Knows How to Use CODEPAGE_1253MS-Windows Greek codepage 1253. with MariaDB
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]
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]
AnyOne Who Knows How to Use CODEPAGE_1253MS-Windows Greek codepage 1253. with MariaDB
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
> 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
- Mensajes: 485
- Registrado: Jue Jul 12, 2007 8:48 pm
- Ubicación: Athens Greece
AnyOne Who Knows How to Use CODEPAGE_1253MS-Windows Greek codepage 1253. with MariaDB
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.
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.
AnyOne Who Knows How to Use CODEPAGE_1253MS-Windows Greek codepage 1253. with MariaDB
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
> I gave up MySql/MariaDB are not for me (diden't like greeks)
> still the same

> 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