DevOps, CI/CD and Automation

Hi everyone

Im testing this script through my Oracle Express database but for some reason it doesnt show the letters å ä ö for some words in my combo box. I checked the nfs_lang in regedit and it was set to SWEDISH_SWEDEN.WE8MSWIN1252.

Do i need to add somethng in the select statement in the script so it will show those character ?


Here is the code:

<?php
$db_conn = oci_connect("test", "test", "//localhost/XE");
$cmdstr = "select FIN_PHRASE from FIN_PHRASE Order by FIN_PHRASE";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);

while ($row = oci_fetch_assoc ($parsed)) {
echo '<option>' . $row['FIN_PHRASE'] . '</option>';
}
?>




// Jan