MsSql Server 2000 collation

[eluser]fdog[/eluser]
You could always extend the text helper to achieve that output.

Code:

/**
* UTF to Latin
*
* Outputs latin.
*
* @accesspublic
* @param    string
* @return    string
*/    
if ( ! function_exists('utf2latin'))
{
    function utf2latin($text)
    {
        $text=htmlentities($text,ENT_COMPAT,'UTF-8');
        return html_entity_decode($text,ENT_COMPAT,'ISO-8859-1');
    }
}

/**
* Latin to UTF
*
* Outputs UTF
*
* @access    public
* @param    string
* @return    string
*/    
if ( ! function_exists('latin2utf'))
{
    function latin2utf($text)
    {
        $text=htmlentities($text,ENT_COMPAT,'ISO-8859-1');
        return html_entity_decode($text,ENT_COMPAT,'UTF-8');
    }
}

Use the latin2utf function when you work with mssql.