Results 1 to 3 of 3
Thread: sql server datatype
Jun 1, 2004, 06:40 #1
sql server datatype
I just stumbled into something which kinda of makes sense but I'm not 100% sure about... hope one of you can help.
I have a field as nvarchar.
I had the sql checking it: select blar from blar where blar = 0
weird thing is in the enterprise manager DTS the query parsed as ok. Overall the DTS failed because it came across some characters it said it couldn't handle.
The query changed to: select blar from blar where blar = '0'
and everything worked fine from there on.
What I'm wondering is, can nvarchar accept numeric values as well as string values?
if it can then the above all makes sense, if it doesn't... have I just found a bug?Don't you just hate it when it works first time.
Jun 1, 2004, 06:46 #2
- Join Date
- Nov 1999
- Mechanicsburg, PA
- 123 Post(s)
- 1 Thread(s)
Jun 1, 2004, 06:52 #3Originally Posted by DaveMaxwell
unless DTS uses ADO and I didn't know it???Don't you just hate it when it works first time.