Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Posts
    54
    Plugin Contributions
    0

    Default Greek Database code

    Hi, I had this issue on my other shop so I want to do this correctly this time as I remember that I was told I had to do it from the beginning.

    I am setting up a new shop and I need to have Greek codepage in my database tables by default. I created a new db and set Greek as default language.

    When I run ZC setup though, all tables where populated as latin1_general_ci.

    What do I have to do so that all tables are populated with greek codepage?

  2. #2
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Greek Database code

    Set your database to utf8_general_ci before installing Zen Cart so that the tables will be created that way.
    And set the DB_CHARSET in your Zen Cart install settings file so that it uses utf8 when building things.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Aug 2010
    Posts
    54
    Plugin Contributions
    0

    Default Re: Greek Database code

    Quote Originally Posted by DrByte View Post
    Set your database to utf8_general_ci before installing Zen Cart so that the tables will be created that way.
    And set the DB_CHARSET in your Zen Cart install settings file so that it uses utf8 when building things.
    Thanks,
    Stupid me, that's what I did but I forgot that I copied all original files back to the server and my install parameters file was overwritten

    Anyway, it seems that my db is now utf8_general_ci. I hope that Greek works fine this time.

 

 

Similar Threads

  1. php code to update database HELP pls
    By crazycucumber in forum General Questions
    Replies: 5
    Last Post: 3 Oct 2009, 12:26 PM
  2. Updating database using own code
    By arthurdent in forum General Questions
    Replies: 2
    Last Post: 23 Jul 2009, 12:32 AM
  3. Backup MySQL Database: Result code: 2
    By theapeman in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 4 Aug 2007, 06:08 AM
  4. It's all Greek to me!
    By Hound in forum PayPal Express Checkout support
    Replies: 0
    Last Post: 28 Jan 2007, 04:03 PM

Posting Permissions

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