Home > Archive > MS SQLCE > October 2005 > problem concat varchar for stored in table field TEXT









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author problem concat varchar for stored in table field TEXT
Jesus Suarez

2005-10-27, 7:53 am

hello,
I have a problem with varchar, i am concat n variables varchar for
stored in field type of text.
The problem is that at concat this variable type varchar, the value
stored in the database is trucanta,
whatis is happening?

--
Jesús Suarez López
Responsable Técnico de Galiciaempleo.net
Galiciaempleo.net
C/ Curros Enriquez 43 bajo
mail: soporte@galiciaemple
o.net
Tlf 981 217 855


Darren Shaffer

2005-10-27, 9:23 am

SQL CE only supports UNICODE types. So you need to be
putting NVARCHAR characters into your NTEXT field.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Jesus Suarez" <djalma59@hotmail.com> wrote in message
news:ekadLhu2FHA.3228@TK2MSFTNGP15.phx.gbl...
> hello,
> I have a problem with varchar, i am concat n variables varchar for
> stored in field type of text.
> The problem is that at concat this variable type varchar, the value
> stored in the database is trucanta,
> whatis is happening?
>
> --
> Jesús Suarez López
> Responsable Técnico de Galiciaempleo.net
> Galiciaempleo.net
> C/ Curros Enriquez 43 bajo
> mail: soporte@galiciaemple
o.net
> Tlf 981 217 855
>
>



Jesus Suarez

2005-10-27, 9:23 am

i not using SQL CE. I using sql server 2000. i have a limitation with fields
type varchar

"Darren Shaffer" < darrenshaffer@discus
sions.microsoft.com> escribió en el
mensaje news:ORvIQ7v2FHA.1420@TK2MSFTNGP09.phx.gbl...
> SQL CE only supports UNICODE types. So you need to be
> putting NVARCHAR characters into your NTEXT field.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
> "Jesus Suarez" <djalma59@hotmail.com> wrote in message
> news:ekadLhu2FHA.3228@TK2MSFTNGP15.phx.gbl...
>
>



Darren Shaffer

2005-10-27, 5:28 pm

you're in the wrong newsgroup - this group is for SQL CE/SQL Mobile
questions
and answers. I suggest posting to "microsoft.public.sqlserver.programming"
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Jesus Suarez" <djalma59@hotmail.com> wrote in message
news:uEctNBw2FHA.892@TK2MSFTNGP12.phx.gbl...
>i not using SQL CE. I using sql server 2000. i have a limitation with
>fields type varchar
>
> "Darren Shaffer" < darrenshaffer@discus
sions.microsoft.com> escribió en el
> mensaje news:ORvIQ7v2FHA.1420@TK2MSFTNGP09.phx.gbl...
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com