Announcement

Collapse
No announcement yet.

Never learnt Latin or Swedish - Why should my DB?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Never learnt Latin or Swedish - Why should my DB?

    I had a quick glance at the DB interface within Plesk where you can run inquires away from a web page form input. As with Lycos upon returning a result of a search it displays the query with the result.

    GULP! never ever have i witnessed such lengthy gobbledegook lol. What on earth were the references to Latin and other things i saw.

    The Lycos output and every other example i've seen in text books and in web tutorials never mentions half the syntax that was thrown in. My fear is that i have to add loads of words to every single database query embedded in my php scripts.

    Will i have to add such baggage to a query now that i've moved to WHUK?.

    I've used a simple basic connnection and query syntax for years on the Lycos servers without any problem. I never had to include lengthy quotes about collation languages. Unfortunately, it is throwing up error messages stopping the query succeeding and i don't know why.

    For now can anyone tell me if i should change the 'Show MySql System Variables' mentioned below to a different utf8 option?

    Many sincere thanks in advance to any assistance on the above question.

    character set client utf8 (Global value) latin1
    character set connection utf8 (Global value) latin1
    character set database latin1
    character set filesystem binary
    character set results utf8 (Global value) latin1
    character set server latin1
    character set system utf8
    character sets dir C:\Program Files\Parallels\Plesk\Databases\MySQL\share\charse ts\
    collation connection utf8_unicode_ci
    (Global value) latin1_swedish_ci
    collation database latin1_swedish_ci
    collation server latin1_swedish_ci


    EDIT UPDATE

    I've pasted one example of the returned query in phpMYadmin. Some of the offending words that i've never come across are 'convert' 'latin1' 'collate'.

    SELECT *
    FROM `whatever`
    WHERE `this` LIKE CONVERT( _utf8 'tonga'
    USING latin1 )
    COLLATE latin1_swedish_ci
    LIMIT 0 , 30

    Queries in my previous hosts phpMyadmin had none of those. It would just have returned
    SELECT *
    FROM `whatever`
    WHERE `this` LIKE 'that'
    LIMIT 0 , 30
    Last edited by perplexed; 24-02-09, 03:55 AM.

  • #2
    Incidentally, the flash tutorials concerning creating databases don't work.

    IE says 'Problems with this WebPage might prevent it from being displayed properly or functioning properly.
    Line: 17
    Char: 1
    Error: 'window,document.movie' is null or not an object.
    Code: 0
    URL: http://www.webhosting.uk.com/php/phpma_createtable.html
    Last edited by perplexed; 25-02-09, 04:09 PM.

    Comment


    • #3
      Hi,

      Latin1 is the default database charset for MYSQL. You can just insert any SQL query and it should work, as long as it's in the correct format
      Webhosting.UK.com || cPanel VPS Hosting || Reseller Hosting

      Sales: 0808-262-0855
      Support: 0800-612-8725
      International: +44 191 303 8191

      Comment


      • #4
        Originally posted by perplexed View Post

        Queries in my previous hosts phpMyadmin had none of those. It would just have returned
        SELECT *
        FROM `whatever`
        WHERE `this` LIKE 'that'
        LIMIT 0 , 30
        Yeah, that will work too. I usually just delete the other stuff
        black-dog
        4theweb.co.uk Web stuff
        slipperyhill.co.uk Band

        Comment

        Working...
        X