data type appears to be wrong?
data type appears to be wrong?
- Subject: data type appears to be wrong?
- From: Theodore Petrosky <email@hidden>
- Date: Tue, 8 Mar 2005 14:15:00 -0800 (PST)
- Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys
I have a postgresql db that I am trying to access. I
finally have 'most' of the pieces working from the
examples that I got from some of the books. So I
thought I would play a little and try connection to a
copy of my live data. My table is using a few columns
that are type 'text' and I have a cocoa app that I
have written to put in the data.
When I try to connect with EOModeler I get an error:
Stack Trace:
JDBCAdaptorException: Invalid character data was
found. This is most likely caused by stored data
containing characters that are invalid for the
character set the database was created in. The most
common example of this is storing 8bit data in a
SQL_ASCII database.
Exception: java.io.IOException: UTF-8 string
representation was truncated
Stack Trace:
java.io.IOException: UTF-8 string representation was
truncated
at
I inited my database with locale = 'C' and the
offending column is a text column that came from my
cocoa app. What can I do? If I SELECT INTO to create a
new table, do I have to change the locale or column
type?
When I insert data into my table (from my cocoa app)
it is in the form:
[[NSString stringWithFormat:@"INSERT INTO mytable
(textcolumn) VALUES ('%@')" , [textViewArea string]];
I am only picking up the string value.
Any ideas?
Thanks,
Ted
__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden