Results 1 to 6 of 6

Thread: inserting special characters into database

  1. #1
    Join Date
    Nov 2010
    Posts
    115
    Thanks
    27
    Thanked 0 Times in 0 Posts

    Default inserting special characters into database

    Hi All,

    I have a registration form where users can register into my site. But some of users from other countries are using some different types(russian or sweden or anyother) of alphabets . When iam selecting from my database those letters are displaying as encoding letters. How can i solve this issue

  2. #2
    Join Date
    Mar 2006
    Location
    Illinois, USA
    Posts
    12,164
    Thanks
    265
    Thanked 690 Times in 678 Posts

    Default

    Use an encoding that supports all of the characters needed. UTF8 (unicode) is the best idea unless you know it will only be European alphabets (not including Arabic, from the list you gave).

    Next, make sure that ALL of your website uses exactly the same encoding. This includes: your HTML (an encoding tag), your HTML pages as text files (the encoding of the file itself), your server (should be fine, but if you are using PHP or another serverside language make sure it isn't converting to another encoding while it processes), and your databases (this can be the most difficult, and make sure it's consistent throughout your database tables). There may be other places where the encoding changes as well. Also, if you are using any 3rd party software like a forum, make sure it is compatible, and look through the admin control panels to find an option to use unicode.
    Daniel - Freelance Web Design | <?php?> | <html>| espa˝ol | Deutsch | italiano | portuguŕs | catalÓ | un peu de franšais | some knowledge of several other languages: I can sometimes help translate here on DD | Linguistics Forum

  3. #3
    Join Date
    Jan 2011
    Posts
    50
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    hi dj...

    i was just wondering if this unicode is ok to use in ASP since i'll be needing this on my web design..i'm not quite good in using HTML but i know the basics...

    thanks

  4. #4
    Join Date
    Sep 2007
    Location
    The Netherlands
    Posts
    1,881
    Thanks
    49
    Thanked 266 Times in 258 Posts
    Blog Entries
    56

  5. #5
    Join Date
    Jan 2011
    Posts
    50
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    oh, thank you...i'll use this when i get a chance...this is good...


  6. #6
    Join Date
    Mar 2006
    Location
    Illinois, USA
    Posts
    12,164
    Thanks
    265
    Thanked 690 Times in 678 Posts

    Default

    Unicode is an underlying format to store information. It can be used with basically any language, since the result is the same HTML. Of course it might cause some problems depending on how you are processing the text. If you aren't manipulating it (just reading and writing) that's fine. But if you need to, for example, search for a shorter version of the text, it might be confused by the different encoding.
    For example, in PHP there are multibyte string functions designed for that type of operation when using unicode. There may be similar things for ASP, though I'm not sure since I don't work with it. But I'm sure that ASP can be used with unicode.
    Daniel - Freelance Web Design | <?php?> | <html>| espa˝ol | Deutsch | italiano | portuguŕs | catalÓ | un peu de franšais | some knowledge of several other languages: I can sometimes help translate here on DD | Linguistics Forum

Bookmarks

Posting Permissions

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