Re: locale problem

Hi,

On Fri, Oct 7, 2011 at 11:48 PM, Hamid A. Toussi <[email protected]> wrote:
> Hello, thanks for your attention.
>
> On Thu, Oct 6, 2011 at 5:36 PM,  <[email protected]> wrote:
>> On Tue, Oct 05, 2011, Hamid A. Toussi wrote:
>>> Everything is working fine except in the case that we want to retrieve or
>>> manipulate non-English text (Farsi) in sql statements.
>>
>> 1.  What goes wrong when you retrieve data?
>>
>
> No record would be returned if we query for a record with some Farsi
> value (in case that libiconv is disabled).
>
>> 2.  What is the output of locale(1) on the working and non-working systems?
>>
>
> I don't have locale on ARM, the output of locale on Fedora x86 is:

Maybe that's the problem?
Can you try to install locale(1) on the ARM machine?

Thank you.

> LANG=en_US.UTF-8
> LC_CTYPE="en_US.UTF-8"
> LC_NUMERIC="en_US.UTF-8"
> LC_TIME="en_US.UTF-8"
> LC_COLLATE="en_US.UTF-8"
> LC_MONETARY="en_US.UTF-8"
> LC_MESSAGES="en_US.UTF-8"
> LC_PAPER="en_US.UTF-8"
> LC_NAME="en_US.UTF-8"
> LC_ADDRESS="en_US.UTF-8"
> LC_TELEPHONE="en_US.UTF-8"
> LC_MEASUREMENT="en_US.UTF-8"
> LC_IDENTIFICATION="en_US.UTF-8"
> LC_ALL=
>
>> 3.  What iconv library, if any, are you using?
>>
> In my recent build, I have used GNU libiconv:
>
> ./configure --host=arm-linux --target=arm-linux
> --prefix=/opt/installed/arm/freetds
> --with-odbc-nodm=/opt/installed/arm/unixODBC_2.3 --enable-static
> --enable-msdblib --with-libiconv-prefix=/opt/fara0/iconv/
>
>>4.  What encoding is used on the server?  Are these nvarchar (UCS2) data,
>  >  or varchar?  If varchar, what collation?
>
> It is text.
>
>
>>
>> 5.  What endian is the ARM running?
>>
>
> I think it is little endian
>
>> 6.  What iconv messages do you see in each machine's TDSDUMP log?
>>
>
> on ARM:
> iconv.c:330:tds_iconv_open(0x29538, ISO-8859-1)
> iconv.c:337:error: tds_iconv_init() returned 1; could not find a name for ISO 88
> 59-1 that your iconv accepts.
>
> on x86 Fedora:
> iconv.c:330:tds_iconv_open(0x90c4138, UTF-8)
> iconv.c:187:local name for ISO-8859-1 is ISO-8859-1
> iconv.c:187:local name for UTF-8 is UTF-8
> iconv.c:187:local name for UCS-2LE is UCS-2LE
> iconv.c:187:local name for UCS-2BE is UCS-2BE
> iconv.c:349:setting up conversions for client charset "UTF-8"
> iconv.c:351:preparing iconv for "UTF-8" <-> "UCS-2LE" conversion
> iconv.c:391:preparing iconv for "ISO-8859-1" <-> "UCS-2LE" conversion
> iconv.c:394:tds_iconv_open: done
>
>
> Thanks,
> Hamid
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>