Re: Zeos Acces + Firebird

"Mike Walker" <mwalker@xxxxxx> wrote in message
news:dfmbqt$12u$1@xxxxxxxxxxxxxxxxx

> Table structure:
>
> field "lastname" is varchar (30): Charset=win1250, Collate = pxw_slov
>
> When I made zquery:
>
> select * from mytable
> where lastname = 'Maric'
> order by lastname
>
> all was OK, but when I tried this:
>
> select * from mytable
> where lastname = 'Mariæ'
> order by lastname
>
> I got next error message:
>
> "Sql Error: arithmetic exception, numeric overflow, or string truncation
> Cannot transliterate character between caracter sets. Error Code: -802.
> Aritmetic overflow or division by zero acurred."

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 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.

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?

Groetjes,
Maarten Wiltink


.

Relevant Pages

  • Re: Reading a file from a specified range
    ... The command that produces the error may be, ... | more than three rows above the error message. ... | character instead of going backwards some defined number of rows. ...
    (comp.lang.cpp)
  • Re: strong passwords
    ... I have seen a user forget a 6 character password in 10-20 seconds though. ... "Herb Martin" wrote in message ... Workstations) as your users will most likely NOT come up with ... >> in an error message that is quite generic and not very informative. ...
    (microsoft.public.win2000.active_directory)
  • Strange display when crashing
    ... This means that the error message can't be read ... character effect is the only reason we've been able to read ... OEM version of Windows 2000 Pro ... Windows is reporting RAM as 228MB, ...
    (microsoft.public.win2000.general)
  • Re: Reading a file from a specified range
    ... The command that produces the error may be, ... more than three rows above the error message. ... character instead of going backwards some defined number of rows. ...
    (comp.lang.cpp)
  • character E as expontial
    ... Is there a way to tell Foxpro NOT to process the character 'E" as ... ?VAL&& this cause error - numeric overflow ... Mike Farnesi ...
    (microsoft.public.fox.programmer.exchange)