Hi everyone.
i have a problem isql utility.
My Server : SQLServer2000
xxx.sql example
---------
insert into Table1
select 's', 'Çarsi '
For example this xxx.sql is my sql table.
I have no problem when running isql queries like below.
But when run this query i cant insert the characters like ç s i to my table.
And also in the profiler i see something like
----------
insert into Table1
select '|', '|ar|si '
-----------
No problem abaot (sa) user language.
i couldnt find any language or character set option in sql query.
isql command
-------------
exec master..xp_cmdshell 'isql /SSQLSERVER /Usa /P /dDATABASE /i D:\XXX.sql'
What sholud i control?
i have a problem isql utility.
My Server : SQLServer2000
xxx.sql example
---------
insert into Table1
select 's', 'Çarsi '
For example this xxx.sql is my sql table.
I have no problem when running isql queries like below.
But when run this query i cant insert the characters like ç s i to my table.
And also in the profiler i see something like
----------
insert into Table1
select '|', '|ar|si '
-----------
No problem abaot (sa) user language.
i couldnt find any language or character set option in sql query.
isql command
-------------
exec master..xp_cmdshell 'isql /SSQLSERVER /Usa /P /dDATABASE /i D:\XXX.sql'
What sholud i control?