problems with polish characters in fieldnames

Article View: borland.public.delphi.database.dotnet

Article #118

Back to borland.public.delphi.database.dotnet Previous Next

#118

From: Rafal Z
Date: Mon, 18 Sep 2006 18:40

15 lines
1531 bytes

Hallo,

   I've migrated an Access database to mysql. The problem is that the 
table contain fields with names containing polish characters. There is 
no problem with mysql, all characters are present and visible. I connect 
to the database from Delphi (Turbo/net) by Ado-Connection. It uses an 
ODBC driver, that comes with new mysql version. I get error: You have an 
error in your SQL syntax.... I suppose that this is due to polish 
characters, that are represented in the names of fields and tables by 
'?'-character. Is there a workaround, or is it better the replace polish 
characters by english characters?

sincerely

Rafal Z

Technical Details

Message-ID: <450ee803@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1effe6,ecab51029a4bea78,start
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Mon, 18 Sep 2006 20:40:11 +0200
From: Rafal Z <rafzio4@wp.pl>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
Newsgroups: borland.public.delphi.database.dotnet
Subject: problems with polish characters in fieldnames
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 62.111.150.186
Message-ID: <450ee803@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1158604803 62.111.150.186 (18 Sep 2006 11:40:03 -0700)
Lines: 15
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail