Home » RDBMS Server » Server Utilities » Field in data file exceeds maximum length Error
Field in data file exceeds maximum length Error [message #299001] Fri, 08 February 2008 08:52 Go to next message
mguimaraes
Messages: 6
Registered: February 2008
Junior Member
Dears,
I´m having this problem, if some one can help me.

I´m trying to do a loader from Mysql to Oracle, in mysql I have one table with more than 100.000 rows and when I do the loader 9 rows show the error “Field in data file exceeds maximum length”. The field in MySQL is “description varchar(600)” in oracle is “description varchar2(600)” and in the archive of loader is “description char(600).

I did a query to be sure that is not only 9 filds that use the all 600 position of the field, the result was more than 100, so, I can eliminate this situation.

Some body had this problem before are have a guess to resolve?

Thanks a lot,
Marcelo
Re: Field in data file exceeds maximum length Error [message #299006 is a reply to message #299001] Fri, 08 February 2008 09:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is your database character set?

Regards
Michel
Re: Field in data file exceeds maximum length Error [message #299007 is a reply to message #299006] Fri, 08 February 2008 09:14 Go to previous messageGo to next message
mguimaraes
Messages: 6
Registered: February 2008
Junior Member
In oracle is: CHARACTERSET WE8ISO8859P1

How can I see in Mysql?
Re: Field in data file exceeds maximum length Error [message #299009 is a reply to message #299007] Fri, 08 February 2008 09:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I don't know but if you use phpMyAdmin I think you can see it.
I may be at table level in MySQL.

Regards
Michel
Re: Field in data file exceeds maximum length Error [message #299026 is a reply to message #299001] Fri, 08 February 2008 12:02 Go to previous messageGo to next message
mguimaraes
Messages: 6
Registered: February 2008
Junior Member
Now I found the mysql caracter set:

+----------+-----------------------------+---------------------+--------+
| Charset | Description | Default collation | Maxlen |
+----------+-----------------------------+---------------------+--------+
| big5 | Big5 Traditional Chinese | big5_chinese_ci | 2 |
| dec8 | DEC West European | dec8_swedish_ci | 1 |
| cp850 | DOS West European | cp850_general_ci | 1 |
| hp8 | HP West European | hp8_english_ci | 1 |
| koi8r | KOI8-R Relcom Russian | koi8r_general_ci | 1 |
| latin1 | cp1252 West European | latin1_swedish_ci | 1 |
| latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 |
| swe7 | 7bit Swedish | swe7_swedish_ci | 1 |
| ascii | US ASCII | ascii_general_ci | 1 |
| ujis | EUC-JP Japanese | ujis_japanese_ci | 3 |
| sjis | Shift-JIS Japanese | sjis_japanese_ci | 2 |
| hebrew | ISO 8859-8 Hebrew | hebrew_general_ci | 1 |
| tis620 | TIS620 Thai | tis620_thai_ci | 1 |
| euckr | EUC-KR Korean | euckr_korean_ci | 2 |
| koi8u | KOI8-U Ukrainian | koi8u_general_ci | 1 |
| gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2 |
| greek | ISO 8859-7 Greek | greek_general_ci | 1 |
| cp1250 | Windows Central European | cp1250_general_ci | 1 |
| gbk | GBK Simplified Chinese | gbk_chinese_ci | 2 |
| latin5 | ISO 8859-9 Turkish | latin5_turkish_ci | 1 |
| armscii8 | ARMSCII-8 Armenian | armscii8_general_ci | 1 |
| utf8 | UTF-8 Unicode | utf8_general_ci | 3 |
| ucs2 | UCS-2 Unicode | ucs2_general_ci | 2 |
| cp866 | DOS Russian | cp866_general_ci | 1 |
| keybcs2 | DOS Kamenicky Czech-Slovak | keybcs2_general_ci | 1 |
| macce | Mac Central European | macce_general_ci | 1 |
| macroman | Mac West European | macroman_general_ci | 1 |
| cp852 | DOS Central European | cp852_general_ci | 1 |
| latin7 | ISO 8859-13 Baltic | latin7_general_ci | 1 |
| cp1251 | Windows Cyrillic | cp1251_general_ci | 1 |
| cp1256 | Windows Arabic | cp1256_general_ci | 1 |
| cp1257 | Windows Baltic | cp1257_general_ci | 1 |
| binary | Binary pseudo charset | binary | 1 |
| geostd8 | GEOSTD8 Georgian | geostd8_general_ci | 1 |
| cp932 | SJIS for Windows Japanese | cp932_japanese_ci | 2 |
| eucjpms | UJIS for Windows Japanese | eucjpms_japanese_ci | 3 |
+----------+-----------------------------+---------------------+--------+
Re: Field in data file exceeds maximum length Error [message #299031 is a reply to message #299026] Fri, 08 February 2008 12:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Which it is for your table?

Regards
Michel
Re: Field in data file exceeds maximum length Error [message #299033 is a reply to message #299001] Fri, 08 February 2008 12:25 Go to previous messageGo to next message
mguimaraes
Messages: 6
Registered: February 2008
Junior Member
All of then are supported by Mysql, but the correspondent of oracle (WE8ISO8859P1) in mysql I beleave it´s (latin1)
Re: Field in data file exceeds maximum length Error [message #299045 is a reply to message #299033] Fri, 08 February 2008 13:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
All of them are supported but what is the one currently in use for your table?

Regards
Michel
Re: Field in data file exceeds maximum length Error [message #299047 is a reply to message #299001] Fri, 08 February 2008 13:15 Go to previous messageGo to next message
mguimaraes
Messages: 6
Registered: February 2008
Junior Member
Ok.
the default is:
| latin1 | cp1252 West European | latin1_swedish_ci | 1 |
Re: Field in data file exceeds maximum length Error [message #299052 is a reply to message #299047] Fri, 08 February 2008 13:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
So you have (almost) the same character set in both databases and the same field length definition, I wonder how you can get a maximum length exceeded error.
Post one of the rows in error using code tags and 80 characters per line.

Regards
Michel

[Updated on: Fri, 08 February 2008 13:27]

Report message to a moderator

Re: Field in data file exceeds maximum length Error [message #299062 is a reply to message #299001] Fri, 08 February 2008 14:28 Go to previous messageGo to next message
mguimaraes
Messages: 6
Registered: February 2008
Junior Member
Erro: Record 54289: Rejected - Error on table VEHICLE.CAR, column DESCRIPTION.
Field in data file exceeds maximum length
Re: Field in data file exceeds maximum length Error [message #299064 is a reply to message #299062] Fri, 08 February 2008 14:53 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Post the data.
Read OraFAQ Forum Guide, "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters.
Use the "Preview Message" button to verify.

Regards
Michel
Previous Topic: to_date
Next Topic: Condition in SqlLoader [Merged]
Goto Forum:
  


Current Time: Tue Dec 24 22:33:02 CST 2024