Diakrieten worden niet opgeslagen

Hi,
When I use the update statement "UPDATE tablename SET field =3D
'As=FBca' WHERE fieldid =3D 1" will generate in the field "Asuca". How
is that possible?
When I cut and paste the field within Enterprise Manager the field
looks like "As=FBca".
So... whats the problem?
Thanks,
Ron
Diver
Try
UPDATE tablename SET field =N'Asca' WHERE fieldid = 1
"Diver" <rnooit@.hotmail.com> wrote in message
news:1121756360.293341.217730@.g47g2000cwa.googlegr oups.com...
Hi,
When I use the update statement "UPDATE tablename SET field =
'Asca' WHERE fieldid = 1" will generate in the field "Asuca". How
is that possible?
When I cut and paste the field within Enterprise Manager the field
looks like "Asca".
So... whats the problem?
Thanks,
Ron
|||Uri,
Thanks. But is there any sqlserver setting that i can set for the whole
database?
Ron

Diakrieten worden niet opgeslagen

Hi,
When I use the update statement "UPDATE tablename SET field =3D
'As=FBca' WHERE fieldid =3D 1" will generate in the field "Asuca". How
is that possible?
When I cut and paste the field within Enterprise Manager the field
looks like "As=FBca".
So... whats the problem?
Thanks,
RonDiver
Try
UPDATE tablename SET field =N'Asca' WHERE fieldid = 1
"Diver" <rnooit@.hotmail.com> wrote in message
news:1121756360.293341.217730@.g47g2000cwa.googlegroups.com...
Hi,
When I use the update statement "UPDATE tablename SET field =
'Asca' WHERE fieldid = 1" will generate in the field "Asuca". How
is that possible?
When I cut and paste the field within Enterprise Manager the field
looks like "Asca".
So... whats the problem?
Thanks,
Ron|||Uri,
Thanks. But is there any sqlserver setting that i can set for the whole
database?
Ron

Diakrieten worden niet opgeslagen

Hi,
When I use the update statement "UPDATE tablename SET field =3D
'As=FBca' WHERE fieldid =3D 1" will generate in the field "Asuca". How
is that possible?
When I cut and paste the field within Enterprise Manager the field
looks like "As=FBca".
So... whats the problem?
Thanks,
RonDiver
Try
UPDATE tablename SET field =N'Asûca' WHERE fieldid = 1
"Diver" <rnooit@.hotmail.com> wrote in message
news:1121756360.293341.217730@.g47g2000cwa.googlegroups.com...
Hi,
When I use the update statement "UPDATE tablename SET field ='Asûca' WHERE fieldid = 1" will generate in the field "Asuca". How
is that possible?
When I cut and paste the field within Enterprise Manager the field
looks like "Asûca".
So... whats the problem?
Thanks,
Ron|||Uri,
Thanks. But is there any sqlserver setting that i can set for the whole
database?
Ron