When uploading a table to Oracle XE using EasyLoader (v8.0) I get the
following error:
MyTable, insert failed for row: 17
ORA-12899: value too large for column "MyColumn" (actual:22,maximum:20)
I suspect that the error is related to language of my database, which is
Slovak (the local computer from which the database is accessed is Slovak
too).
Here is the complete listing of all national language parameters:
NLS_CALENDAR GREGORIAN
NLS_CHARACTERSET AL32UTF8
NLS_COMP BINARY
NLS_CURRENCY Sk
NLS_DATE_FORMAT DD.MM.RR
NLS_DATE_LANGUAGE SLOVAK
NLS_DUAL_CURRENCY Sk
NLS_ISO_CURRENCY SLOVAKIA
NLS_LANGUAGE SLOVAK
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_NCHAR_CONV_EXCP FALSE
NLS_NUMERIC_CHARACTERS ,.
NLS_SORT SLOVAK
NLS_TERRITORY SLOVAKIA
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD.MM.RR HH24:MI:SSXFF
NLS_TIMESTAMP_TZ_FORMAT DD.MM.RR HH24:MI:SSXFF TZR
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
Furthermore, in tables that were successfully uploaded, special slovak
characters are replaced with question marks.
How to overcome this? Any hint?
--
Jaromir SVASTA
Hydrogeologist
Geological Survey of Slovak Republic
Mlynska dolina 1
817 04 Bratislava
Slovak Republic
Tel: +421 2 59375326
Mobile: +421 908 783589
Fax: +421 2 54771940
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
