Problem with an empty unicode string

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

Article #934

Back to borland.public.cppbuilder.database.ado Previous Next

#934

From: 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

Technical Details

Message-ID: <42385222$2@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsfeed.media.kyoto-u.ac.jp!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,a51e5ed847347075,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Leen Keus" <lj.keus@freeler.nl>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Problem with an empty unicode string
Date: Wed, 16 Mar 2005 16:34:58 +0100
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 62.177.192.202
Message-ID: <42385222$2@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1110987298 62.177.192.202 (16 Mar 2005 07:34:58 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsfeed.media.kyoto-u.ac.jp!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail