Problem with an empty unicode string

Thread View: borland.public.cppbuilder.database.ado

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Leen Keus Wed, 16 Mar 2005 15:34

#934

Author: Leen Keus
Date: Wed, 16 Mar 2005 15:34

23 lines
1656 bytes

Hi,

I have two SQL Server databases:
db1, has tables with varchar and text fields and
dbuni, has tables with nvarchar and ntext fields

On my form I use TDBEdit and TDBMemo controls to manage the data.

If I do an update (or insert) on db1 everything works fine.
If I do an update or insert on dbuni I get the following EOleException, when 
I try to enter an empty string in the db:

Disallowed implicit conversion from data type text to data type nvarchar, 
table '<table name>', column '<fieldname>'. Use the CONVERT function to run 
this query.

I feel it has to do something with the connection string, but I don't know 
which property I must set.

Any one have a suggestion?

Thanks,
Leen

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads