I have exhausted every source that I can find online to fix this echo.

jbeitz107 · Dec 7, 2014

I have tried so many freaking text encoding and none work. It either shows all incorrect or the diamonds with the question mark in the echo. Currently this is what it shows: ~Vishni¢Óez~ when it should show ~Vishni†ez~. If you guys can offer me a hand that would be great. Thanks for your time.

PHP:

<?php
// Tried multiple text encoding techniques and none show correctly!
include('config/config.php'); 
 ?>
<form id="finduser"  method="POST" action="">
<input type='text' id='name' name='name'>
<input type="Submit" Value="Search for User">
<input type="hidden" name="action" value="submitted">
</form>
<?php
if ($_POST['action'] == 'submitted')
{
$name=$_POST['name'];
error_reporting(E_ALL);
ini_set('display_errors', 1);
global $link;
mssql_select_db("Tantra",$link);
$row = mssql_query("SELECT * FROM GameInfo00 WHERE CharacterName = '$name'")or die('Error with query');
$final = mssql_fetch_array($row)or die('Cannot continue query');
echo $final[7];
}
?>

Negata · Dec 7, 2014

What are some approaches you've tried without luck?

GHOST107 · Dec 7, 2014

Don't know if it will help, if your using MSSQL set the column type to nVarchar, or nText(from Varchar or Text) where you have unicode text, inserted in the database, and set your page charset:

Code:

<meta charset="UTF-8">

jbeitz107 · Dec 7, 2014

tested in both nVarchar as well as nText with the meta charset as you have posted and it is doing the exact same thing as before which is to show the diamonds with question marks in it as predicted.

TimeBomb · Dec 7, 2014

Your code is susceptible to

You must be registered to see links

. You should fix this by using

You must be registered to see links

. Doing this will allow your database to treat the query as a query, and the data as data. Currently, you're treating the data as part of the query, which leaves you susceptible to SQL injection. Note that simply filtering the input string with PHP functions is not enough, as there are certain ways to exploit through that.

You must be registered to see links

makes this easy, and should be available to you with the mssql lib that you're currently using. It may also help with your encoding issue, as you'd be treating the character name as data rather than as part of the query.

Something along the lines of:

PHP:

$statement = $pdo->prepare("SELECT * FROM GameInfo00 WHERE CharacterName = :characterName");
$statement->execute(array(':characterName' => $name));

jbeitz107 · Dec 7, 2014

I already have sql injection blocks in place but, this is a simple test in order to echo the correct values from mssql server in php. This is all I asked about for the time being. Thank you for your concern though. I will give your idea try though to see if it works.

Did not echo the correct values again.

NubPro · Dec 8, 2014

PHP:

<?php
$mysqli->query("update table set hash = N'~Vishni†ez~' where id =1");
$test = mysqli_fetch_row($mysqli->query("select table from gd_cache where id = 1"));
echo $test[0];
?>

win.

==
btw, it only took me 5 minutes to do research and test.

jbeitz107 · Dec 8, 2014

This is NOT mysql. This is Microsoft SQL server. And yes I can do that but, this system is auto updated which means it is updated via exe file and not through the website. It only displays through the website after. Nice try though NUBpro but, you failed. LOL

GHOST107 · Dec 8, 2014

But if you had a table that stores data in Multibyte, and then you change it to Unicode, the old data would look the same and will not update to unicode.

So what NubPro says is your application stores data in Multibyte in the database, you have to change the query in your application with N'%s'(or what ever your application is using), for it to store in Unicode.

jbeitz107 · Dec 9, 2014

Ok maybe this will help you guys understand a bit more. This is php version 5.3.1 in wampserver.

XGLADEADOR · Dec 9, 2014

Where are you watching echo on Web or MSSQL?

if is on web add this on your php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
your code
</html>

alxndr · Dec 9, 2014

I think it's about an issue in the mssql driver

NubPro · Dec 9, 2014

jbeitz107 said:
This is NOT mysql. This is Microsoft SQL server. And yes I can do that but, this system is auto updated which means it is updated via exe file and not through the website. It only displays through the website after. Nice try though NUBpro but, you failed. LOL

appreciate the sarcasm.

You are not providing adequate information for us to understand the situation.
At the moment, I have literally absolute idea what you're looking for. Have fun fixing it yourself and I won't mind if I've been called as a newbie because I am.

Good luck.

jbeitz107 · Dec 9, 2014

I was making fun of your name not you in general. Anyhow definitely thank you for your attempt but, we did finally figure out what was going on and yes I am an idiot for not thinking of it sooner. The files were saved as UTF8 instead of ANSII.

TimeBomb · Dec 10, 2014

Glad you figured it out! In the future, you may want to consider being more specific when explaining what you've already tried.
When you said:

I have tried so many freaking text encoding and none work

Some people may have assumed that you had already tried saving it as ANSII.

jbeitz107 · Dec 10, 2014

if it crossed my mind i would have shared but, it didn't until the dead last thing that was done. lol

NubPro · Dec 29, 2014

Oh well. This is embarrassing.

I had this

$asset = $PDO->prepare("SELECT Name FROM dbo.Character WHERE AID = '2'");

Output:

Array ( [Name] => ?????????? [0] => ?????????? )

Actual text is ♥♥♥♥♥♥♥♥♥♥

And yes, this time around I am using SQL server. I just don't understand why it wouldn't work. :blushing:

jbeitz107 · Dec 29, 2014

NubPro · Dec 29, 2014

jbeitz107 said:
<meta charset=ISO-8859-1>
The same problem I had.

you put that in the html?
If so, I don't think so that's my problem.

Taiga · Dec 29, 2014

Use HTML 5, set character set to UTF8. Make sure your database

Code:

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Title of the document</title>
</head>

<body>
Content of the document......
</body>

</html>

I also suggest to make sure that your server stores the information in a unicodeformat (utf8)

You must be registered to see links

Welcome!

I have exhausted every source that I can find online to fix this echo.

Custom Title Activated

Watching from above

Junior Spellweaver

Custom Title Activated

Moderator

Custom Title Activated

Hello!

Custom Title Activated

Junior Spellweaver

Custom Title Activated

Newbie Spellweaver

Newbie Spellweaver

Hello!

Custom Title Activated

Moderator

Custom Title Activated

Hello!

Custom Title Activated

Hello!

◝(⁰▿⁰)◜Smile◝ (⁰▿⁰)◜

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor