Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2012
    Posts
    3

    Red face Unanswered: Special character changing to zero

    Hello,

    I have a column with value "2/T" when it is assigned to another column it is becoming "20T". The special character is replced with zero. Please advise.

  2. #2
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hi,

    Can you give an example please.

    Cheers
    Last edited by Catarrunas; 04-20-12 at 10:56.

  3. #3
    Join Date
    Apr 2012
    Posts
    3

    Smile

    I ahve given the example in my question. In "2/T" the special character "/" is changed to zero (0).

    Thanks!

  4. #4
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hi,

    So i tried to replicate your situation, and that character for me works fine.
    Your problem might be, charset... Here is the example i made:

    create table #temp1 (
    name varchar(10)
    )

    insert into #temp1 values ('2/T');
    insert into #temp1 values ('[\"<`@');

    set char_convert "iso_1"
    select * from #temp1

    set char_convert "utf8"
    select * from #temp1

    set char_convert "cp850"
    select * from #temp1

    drop table #temp1

    --resultSS--

    name
    2/T
    [\"<`@

    name
    2/T
    [\"<`@

    name
    2/T
    Ɠ[\"<`@


    ---------
    As you can see when my charset is 'cp850', some of my characters are strange. So i sugest you start by checking charset and sort order.
    Do some experiments like those and probably you will find a solution.

  5. #5
    Join Date
    Apr 2012
    Posts
    3
    Thanks Sir! I will try and get back to you!!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •