Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Sep 2002
    Posts
    462
    Thanks
    0
    Thanked 20 Times in 20 Posts

    show databases not listing UTF8 db's

    Ok back to square one! When I use the following code to get
    a list of all our databases, it only shows db's that 'Collation' are in latin1
    not our UTF8 one how can I fix this?

    Code:
    $Qry = mysql_query("SHOW DATABASES");
    while ( $row = mysql_fetch_assoc($Qry) ) {
     print_r($row);
    //echo $row['Database'].'<br />';
    
    }
    Last edited by c1lonewolf; 02-03-2014 at 08:10 PM.
    NO Limits!! DHCreationStation.com
    ------------------------------------------------------------
    For projects using MediaTypes (MIMETypes) visit E-BAM.net -(updated weekly)

    Broken items wanted for tinkerin'! PostItNow@BrokenEquipment.com
    Global Complaint Dept.

  • #2
    Regular Coder
    Join Date
    Sep 2002
    Posts
    462
    Thanks
    0
    Thanked 20 Times in 20 Posts
    resolved, but I can't figure out to to get this thread to delete.
    NO Limits!! DHCreationStation.com
    ------------------------------------------------------------
    For projects using MediaTypes (MIMETypes) visit E-BAM.net -(updated weekly)

    Broken items wanted for tinkerin'! PostItNow@BrokenEquipment.com
    Global Complaint Dept.


  •  

    Posting Permissions

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