| Author |
Include French (or other European) words in a SQL statement
|
|
| scheng@vtecsys.com.sg 2006-09-18, 3:55 am |
| Hi all,
I was unable to include a French word in a SQL statement :
MemberTable{Prop:SQL} =3D 'select * from "MemberTable" where
"SurName" like ''%L'extr=EAme%''
It's ok if I use English names only.
Any suggestion.
| |
| JonWat 2006-09-20, 6:55 pm |
|
scheng@vtecsys.com.sg wrote:
> Hi all,
>
> I was unable to include a French word in a SQL statement :
>
> MemberTable{Prop:SQL} =3D 'select * from "MemberTable" where
> "SurName" like ''%L'extr=EAme%''
>
> It's ok if I use English names only.
>
> Any suggestion.
Is it the circonflex or the single quote causing the problem?
| |
| scheng@vtecsys.com.sg 2006-09-21, 3:55 am |
| Hi Jon,
It's the circonflex.
JonWat wrote:
> scheng@vtecsys.com.sg wrote:
>=20
> Is it the circonflex or the single quote causing the problem?
| |
| JonWat 2006-09-21, 6:55 pm |
| I ask because the example you give is obviously wrong.
'select * from "MemberTable" where
"SurName" like ''%L'extr=EAme%''
doesn't even compile, let alone send the right string to the back end.
famcomp{Prop:SQL} =3D 'Select * from famcomp where noals like ''' &
'%=E0=E9%'''
correctly sends
Select * from famcomp where noals like '%=E0=E9%'
to the back end
Jon
scheng@vtecsys.com.sg wrote:[color=darkred]
> Hi Jon,
>
> It's the circonflex.
>
> JonWat wrote:
|
|
|
|