 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Pawel
Guest
|
 Posted: Mon Nov 03, 2003 5:47 pm Post subject: dbexpress & MySQL & national charsets |
 |
|
Hi all,
I've got a database on a MySQL server, which I want to access from my app
written in Delphi6 environment. The problem is that national characters in
my database are encoded in other encoding (in my case ISO 8859-2) than the
windows encoding (WinCP-1250).
Some database-access components (like Zeos - www.zeoslib.net) can transcode
character sets on-the-fly, but I don't know how can I do this in
dbExpress... Someone's got any suggestions?
pawel
|
|
| Back to top |
|
 |
Dmitry Arefiev [gs-soft.r
Guest
|
| Posted: Mon Nov 03, 2003 8:16 pm Post subject: Re: dbexpress & MySQL & national charsets |
|
|
Hello !
dbExpress drivers completely "believe" into RDBMS client.
If RDBMS client will translate code pages "on fly", then dbExp
will return data in required code page. MySQL has SET
CHARACTER SET command. So, look for it details and
also for other similar MySQL options.
Regards,
Dmitry
--
Dmitry Arefiev, gs-soft Company, www.gs-soft.com
Personal - www.da-soft.com
Mood - http://www.funpix.ru/photos/computers/main2.html#2
SAPx - Delphi to SAP R/3 direct access
Saphir - SAP R/3 metadata on your fingertips
MetaBase - ERWIN model in Delphi applications
NCOCI8 - Freeware Delphi to ORACLE direct access
Pawel wrote:
| Quote: | Hi all,
I've got a database on a MySQL server, which I want to access from my app
written in Delphi6 environment. The problem is that national characters in
my database are encoded in other encoding (in my case ISO 8859-2) than the
windows encoding (WinCP-1250).
Some database-access components (like Zeos - www.zeoslib.net) can transcode
character sets on-the-fly, but I don't know how can I do this in
dbExpress... Someone's got any suggestions?
pawel
|
|
|
| Back to top |
|
|
Pawel
Guest
|
| Posted: Sat Nov 15, 2003 4:17 pm Post subject: Re: dbexpress & MySQL & national charsets |
|
|
"Dmitry Arefiev [gs-soft.ru]" <darefiev (AT) gs-soft (DOT) ru>:
| Quote: | dbExpress drivers completely "believe" into RDBMS client.
If RDBMS client will translate code pages "on fly", then dbExp
will return data in required code page. MySQL has SET
CHARACTER SET command. So, look for it details and
also for other similar MySQL options.
|
I've checked the "SET CHARACTER SET" - it only changes the character set
used while sorting the data.
Anyone has any other ideas?
pawel
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
