Subject | Firebird 2: problems with UTF8 database: arithmetic exception, numeric overflow, or string truncation |
---|---|
Author | Martijn Tonies |
Post date | 2006-01-18T13:09:37Z |
Hi,
I've created an UTF8 database, upon the first query in a TIBOQuery,
I get:
arithmetic exception, numeric overflow, or string truncation
This seems to have something to do with the internal IBO queries,
cause when doing it a second time, everything works fine.
This _only_ happens on the first query.
A SQL trace shows this as the last IBO query:
SELECT R.RDB$RELATION_ID || '=', R.RDB$RELATION_NAME
FROM RDB$RELATIONS R
ORDER BY 1 ASC
Hope this helps.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
I've created an UTF8 database, upon the first query in a TIBOQuery,
I get:
arithmetic exception, numeric overflow, or string truncation
This seems to have something to do with the internal IBO queries,
cause when doing it a second time, everything works fine.
This _only_ happens on the first query.
A SQL trace shows this as the last IBO query:
SELECT R.RDB$RELATION_ID || '=', R.RDB$RELATION_NAME
FROM RDB$RELATIONS R
ORDER BY 1 ASC
Hope this helps.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com