[fpc-pascal] request for help: connecting to WIN1251 (ANSI) codepaged DB (FB1.0.3) in Lazarus
Joost van der Sluis
joost at cnoc.nl
Mon Apr 26 12:54:03 CEST 2010
On Thu, 2010-04-01 at 20:19 +0700, 62mkv wrote:
> when trying to connect to FB 1.0.3 server, to database that was
> created using WIN1251 (Windows Ansi Cyrillic) CHARSET, via SqlDB
> TIBConnection component, all Lazarus visual components display ASCII
> (32-127) characters OK, but all Cyrillic characters are displayed as
> I cannot convert DB (anyway, FB 1.0.3 doesn't
> support UTF8) or switch to using another FB.
> I've made requests on several FreePascal\Lazarus forums, all states
> that I need either to migrate to migrate to more recent version of
> FB (most popular advice, which I cannot follow) or "patch" SqlDB
> components so that they should make on-the-fly AnsiToUTF8 and vice versa conversion
Why didn't you try that? It's a proper solution.
> Please tell me, is it the only way, and if yes, than how to do it,
> more exactly, cause I'm a terribly new to Lazarus
You can try to set the character-set of the FB-client when you connect.
And you can be new to Lazarus, but this has nothing to do with Lazarus
or fpc. It's a FB issue, or more general, a conversion to UTF issue.
More information about the fpc-pascal