Hi Nick<br><br>1) When I use tsql, it said<br><br><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; font-size: medium;">locale is "en_US.UTF-8"<br>
locale charset is "UTF-8"</span><br><br>what does this mean? who is using UTF-8? freetds or the SQL server<br><br>in the log:<br><br>iconv.c:197:names for ISO-8859-1: ISO-8859-1<br>iconv.c:197:names for UTF-8: UTF-8<br>
iconv.c:197:names for UCS-2LE: UCS-2LE<br>iconv.c:197:names for UCS-2BE: UCS-2BE<br>iconv.c:363:iconv to convert client-side data to the "UTF-8" character set<br>iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"<br>
iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"<br><br>again, who is using what encoding? the "client-side data" above does it refer to the SQL server data ? or something eles?<br>
<br>2) when I run isql, in the log it said<br>User Name = [xxx][length = 6 (SQL_NTS)]<br> Authentication = [********][length = 8 (SQL_NTS)]<br>UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'<br>
<br>again, what does this mean? who is using UNICODE?<br><br>Thank you<br><br><div class="gmail_quote">On Fri, Apr 23, 2010 at 3:16 PM, Nick Gorham <span dir="ltr"><<a href="mailto:nick@lurcher.org">nick@lurcher.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im"><a href="mailto:jwan@ea.ucla.edu" target="_blank">jwan@ea.ucla.edu</a> wrote:<br>
</div><div class="im"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Nick,<br>
Thanks for responding:<br>
I did that. The first part appear has error in log as follow: ( if I should send the whole file let me know)<br>
</blockquote>
<br></div>
I can only assume its failing to find the ini file or the driver conf file, its getting past unixODBC into the driver in all cases.<div><div></div><div class="h5"><br>
<br>
-- <br>
Nick<br>
_______________________________________________<br>
unixODBC-support mailing list<br>
<a href="mailto:unixODBC-support@mailman.unixodbc.org" target="_blank">unixODBC-support@mailman.unixodbc.org</a><br>
<a href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support" target="_blank">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a><br>
<br>
</div></div></blockquote></div><br>