Value problem in mysql

Last post 09-05-2008 12:54 PM by Karrar666. 2 replies.

Sort Posts:

  • Value problem in mysql

    08-30-2008, 1:02 PM
    • Member
      point Member
    • SoulReaver
    • Member since 12-27-2006, 6:10 PM
    • Posts 6

    Hello i'm trying to get the values from mysql at my webpage.

     

    First all my tables are latin5 and connection type is latin5 at mysql server. Indeed, when i send a select query to my database, the characters like "ı" or "ç" or "ş" returns like "?".

     

    Also a mybb system is uploaded to my website. Mybb returns the true characters but the asp.net surface has a problem about it.

     

    How can i solve this problem? Every webpage send me a query like SET NAMES 'latin5' or a stmt=SET NAMES Latin5 to my connection. But it's not working.

     

    How can i translate  "ı" or "ç" or "ş" to real  values?

     

    Thank you very much.

    MCTS.net
    MCP.net
  • Re: Value problem in mysql

    08-31-2008, 9:53 AM
    • Participant
      1,328 point Participant
    • NecroxPy
    • Member since 08-17-2008, 1:37 PM
    • Asunción - Paraguay
    • Posts 244

    change your collation in mysql to latin_general. In your asp.net change the meta tag languaje to utf-8

    Regards Smile

    Christian Manuel Amado Silva
    [MCITP] Windows Vista Consumer Support Technician
    [MCTS] Windows Vista, Configuration
    [MCTS] .NET Framework 2.0: Web Applications
    [MCTS] Microsoft Windows Mobile 5.0 Application Development
    [MCTS] Microsoft SQL Server 2005
    [MOS] Microsoft Office Master Specialist

    Mark a post as an answer when it is
  • Re: Value problem in mysql

    09-05-2008, 12:54 PM
    • Member
      30 point Member
    • Karrar666
    • Member since 08-31-2008, 8:39 AM
    • IRAQ
    • Posts 10

     "User Id=root;Password=YouPassword;Port=3306;Database=DatabaseNameCharacter Set=utf8;"

Page 1 of 1 (3 items)