Hi all, I'm hoping someone can help me understand this:
Firebird v2.5.3, Windows (XP or 7(, tried on IBO and FlameRobin, on a database created with default character set WIN1252 (also used as connection character set). This: SELECT Upper(_win1252 'ƒ') FROM RDB$DATABASE (Where 'ƒ' is decimal 131 / 0x83) Gives me error 335544321 arithmetic exception, numeric overflow, or string truncation Cannot transliterate character between character sets. Experimenting I get: SELECT Upper(_win1252 x'80') FROM RDB$DATABASE -- works SELECT Upper(_win1252 x'81') FROM RDB$DATABASE -- works SELECT Upper(_win1252 x'82') FROM RDB$DATABASE -- works SELECT Upper(_win1252 x'83') FROM RDB$DATABASE -- FAILS SELECT Upper(_win1252 x'84') FROM RDB$DATABASE -- works I do not understand. x83 is (according to my research) a valid international character in 1252 - and anyway, 0x81 doesn't give the error and it isn't a valid character. This has come about because I had some searches failing in an existing database. Many users have cut-n-paste from emails, so some blob fields have ended with all sorts of stuff that Firebird happily accepted and saved - but now won't let me search with Upper. -- Geoff Worboys Telesis Computing Pty Ltd ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
