Re: Zeos Acces + Firebird

> Your table is encoded in characterset windows-1250, it says so right
> there. Judging from your email address, that's probably an excellent
> choice.

You're right.


> You don't say what characterset is selected in the window where you
> typed your query, but let's suppose it's windows-1252, which is the
> default. That puts the a-e ligature, U+00E6, in codepoint $e6.

No, it isn't "ae", it's " c' ", but it's the same problem.

> Now compare http://www.microsoft.com/globaldev/reference/sbcs/1252.mspx
> to http://www.microsoft.com/globaldev/reference/sbcs/1250.mspx, and
> try hard to locate U+00E6 in the latter. There's a cookie in it for you
> if you can find it, but in a codepage named "Central Europe", I doubt
> that there was ever much demand for it.
>
> So your error message is right on the money. The database server really
> is being asked to, and cannot, transliterate that character.
>
> Does Firebird support the nvarchar datatype?

No, Firebird supports varchar and char. But Firebird is OK. When I tried to
make Query in "IB Expert" all was OK. "Zeos Access" components has a problem
because I can't find a way to "tell" it to use codepage Win-1250 with
communication to my database.

My problem could solve only person who use "Zeos Access" components and
knows how to set codepage in database connection properties to "win1250".

Mike


.

Relevant Pages

  • Re: Need input from Firebird users for a PostgreSQL vs Firebird comparison.
    ... a characterset per database, also not per table. ... You can, however, define charactersets and collations on a per column level. ... Firebird has VERY VERY rich character and collation support and supports ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: charset problem with =?ISO-8859-1?Q?=27=A4=27_=3F?=
    ... The effects on the existing data depend on the current characterset, new characterset and whether or not the data conforms to the characterset; if you've used the nasty hack to insert data that doesn't conform to the charset then that data will almost certainly be trashed. ... So if you've got an ¤ in the database represented by a Euro, and you change charset ... You might consider creating a new database as a possible alternative to changing the current one, then use exp/imp and verify/fix the new database, then redirect the clients to the new database, then finally delete the old one if it's no longer needed. ...
    (comp.databases.oracle.server)
  • Re: what characterset to use?
    ... would never corrupt your data in a WE8MSWIN1252 database character set ... WE8MSWIN1252 is a *single* byte characterset. ... If your database has been set up correctly (which is ...
    (comp.databases.oracle.server)
  • Re: WE8ISO8859P1 convert to AL32UTF8 unicode character set question
    ... AL32UTF8 database. ... If the varchar2 can be converted to target characterset and can be ... It can cause unpredictable conversion. ... UTF-16 encoded, Data retrieved from or inserted into the database must ...
    (comp.databases.oracle.server)
  • Re: Produce XML with russian text
    ... a 3.23.x MySQL version. ... To get back the data in Memo's and save them in the database there are no problems, only when I want to save them in an external file in an xml with utf-8 encoding. ... retrieving and displaying the data in a Russian characterset. ... As I see all the russian characters are saved in widestring russian characterset in the mysql database, because every of them looks excatly as before save in the Delphi Components like memo. ...
    (borland.public.delphi.thirdpartytools.general)