Subject | [IBO] TIB_Connection: character_set property |
---|---|
Author | Enrico Raviglione |
Post date | 2003-02-12T20:54:08Z |
Hi to all,
i need some clearance about what character_set means.
1) Which is the best character_set choice for a Win application only written
for Italian language ?
2) If i have create a database with default character_set = NONE i must set
something in TIB_Connection character_set or i can leave this property blank
?
3) How can i change the database default character_set from NONE to anyother
?
4) Stored-Procedure launched from a trigger who don't have any dialog with
my client application can be influenced about my application
TIB_Conncetion->Character_set property setting ?
5) If my database have defualt character_set = NONE the operating system set
(Windows Xp Pro or Home) can influence FireBird in some way?
I make some question about this because:
1) i need more clearence
2) i have some strange error only in one test Pc where i have Windows Xp
Home as SO, FireBird Final 1.0 and my client application (LocalProtocol) the
error appear only if i have a stored procedure who log some changed data and
write it into another table on after-update/delete trigger, and appear only
if the operation on table record are made with my procedure (written in IBO
v.4) if i made some record update or delete from IBConsole all work fine.
My procedure are very simple and if i deactivate the SP all work fine.
The error are: ISC_ERROR_CODE 335544351 arithmetic exception, numeric
overflow, or string truncation
Bye,
Enrico.
i need some clearance about what character_set means.
1) Which is the best character_set choice for a Win application only written
for Italian language ?
2) If i have create a database with default character_set = NONE i must set
something in TIB_Connection character_set or i can leave this property blank
?
3) How can i change the database default character_set from NONE to anyother
?
4) Stored-Procedure launched from a trigger who don't have any dialog with
my client application can be influenced about my application
TIB_Conncetion->Character_set property setting ?
5) If my database have defualt character_set = NONE the operating system set
(Windows Xp Pro or Home) can influence FireBird in some way?
I make some question about this because:
1) i need more clearence
2) i have some strange error only in one test Pc where i have Windows Xp
Home as SO, FireBird Final 1.0 and my client application (LocalProtocol) the
error appear only if i have a stored procedure who log some changed data and
write it into another table on after-update/delete trigger, and appear only
if the operation on table record are made with my procedure (written in IBO
v.4) if i made some record update or delete from IBConsole all work fine.
My procedure are very simple and if i deactivate the SP all work fine.
The error are: ISC_ERROR_CODE 335544351 arithmetic exception, numeric
overflow, or string truncation
Bye,
Enrico.