Saving text in russian

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Lüpher Cypher

    Saving text in russian

    Hi,
    I have a table with a field that is to save text in Russian. The text is
    then retrieved by a PHP page. I run a query passing text in windows-1251
    encoding, but when I retrieve it from the db, it shows up all wrong.
    Does anyone know what the problem is?

    Thanks,
    Lüph
  • Lüpher Cypher

    #2
    Re: Saving text in russian

    Lüpher Cypher wrote:[color=blue]
    > Hi,
    > I have a table with a field that is to save text in Russian. The text is
    > then retrieved by a PHP page. I run a query passing text in windows-1251
    > encoding, but when I retrieve it from the db, it shows up all wrong.
    > Does anyone know what the problem is?
    >
    > Thanks,
    > Lüph[/color]

    Nevermind that, I've decided to use Unicode, but here came another problem:

    INSERT INTO tbl (name_ru) VALUES ("Админ");

    will insert only "Адм".. Anyone? :)

    Lüph

    Comment

    • Lüpher Cypher

      #3
      Re: Saving text in russian

      > Nevermind that, I've decided to use Unicode, but here came another
      problem:[color=blue]
      >
      > INSERT INTO tbl (name_ru) VALUES ("Админ");
      >
      > will insert only "Адм".. Anyone? :)[/color]

      Argh, I must be too tired :) Forget it, I have varchar(20) there :))

      Comment

      • Lüpher Cypher

        #4
        Re: Saving text in russian

        Lüpher Cypher wrote:[color=blue][color=green]
        > > Nevermind that, I've decided to use Unicode, but here came another[/color]
        > problem:
        >[color=green]
        >>
        >> INSERT INTO tbl (name_ru) VALUES ("Админ");
        >>
        >> will insert only "Адм".. Anyone? :)[/color]
        >
        >
        > Argh, I must be too tired :) Forget it, I have varchar(20) there :))[/color]

        Actually, not that tired :) name_ru is varchar(120) now, but still saves
        only 3 chars, even if &, #, and ; are escaped.. Anyone? :)

        Lüph

        Comment

        • Lüpher Cypher

          #5
          Re: Saving text in russian

          Lüpher Cypher wrote:[color=blue]
          > Lüpher Cypher wrote:
          >[color=green][color=darkred]
          >> > Nevermind that, I've decided to use Unicode, but here came another[/color]
          >> problem:
          >>[color=darkred]
          >>>
          >>> INSERT INTO tbl (name_ru) VALUES
          >>> ("Админ");
          >>>
          >>> will insert only "Адм".. Anyone? :)[/color]
          >>
          >>
          >>
          >> Argh, I must be too tired :) Forget it, I have varchar(20) there :))[/color]
          >
          >
          > Actually, not that tired :) name_ru is varchar(120) now, but still saves
          > only 3 chars, even if &, #, and ; are escaped.. Anyone? :)
          >
          > Lüph[/color]

          Too tired :) Renamed the wrong field.. Disregard this post..

          Comment

          Working...