really very puzzling

  • Thread starter Thread starter Wajih-ur-Rehman
  • Start date Start date
W

Wajih-ur-Rehman

I have a column in MSSQL that is of type "Text". When i write an xml string
in it, it automatically adds a "?" in front of this string when it inserts
in the database, although it is not part of the string that i am writting.

Using the same code, when i write to the Access database with the column
type as "Memo", it does not add that leading "?" . Any idea whats going on?

Regards
 
Depends on how you actually update this column. It might be that a Unicode
byte order prefix is written before the actual content, and this one then
appears as "?". In general, character codes which could not be converted
from one encoding to another appear as "?"s. As your column is "Text" and
not "NTEXT", this can be the reason.
 
But why not in Access then..... Is Memo field in Access a Unicode Field?

Dmitriy Lapshin said:
Depends on how you actually update this column. It might be that a Unicode
byte order prefix is written before the actual content, and this one then
appears as "?". In general, character codes which could not be converted
from one encoding to another appear as "?"s. As your column is "Text" and
not "NTEXT", this can be the reason.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://www.x-unity.net/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

Wajih-ur-Rehman said:
I have a column in MSSQL that is of type "Text". When i write an xml string
in it, it automatically adds a "?" in front of this string when it inserts
in the database, although it is not part of the string that i am writting.

Using the same code, when i write to the Access database with the column
type as "Memo", it does not add that leading "?" . Any idea whats going on?

Regards
Click to expand...
Click to expand...
 
Back
Top