Обсуждение: Encoding: LATIN2 (hungary)

Hi,

I want to set encoding hungarian language.
I try to set LATIN2, but char order is "áabc..".
The good order is "aábc...".

What is the soultion?

Thx,
Andras
ICQ: `find s-andras@freemail.hu`

Is there an easy way in libpq to get the results from
any query as strings.

Imagine a cgi where you input any query and then it prints
out the rows returned

Something like this example of mysql code:

// fetch each row using mysql_fetch_row
  MYSQL_ROW row;
  unsigned int num_fields;

  if( sql_result ) {
    num_fields = mysql_num_fields( sql_result );

    while( ( row = mysql_fetch_row( sql_result ) ) ) {

      outputBuf_.print( L"<r>" );
      for( unsigned int i = 0; i < num_fields ; i++ ) {
        char * rowVal = row[i];
        if( !rowVal ) {
          rowVal = "";
        }

        outputBuf_.print( L"<c>%a</c>", rowVal );
      }
      outputBuf_.print( L"</r>\n" );
    }
  }

Thanks,

Alex.

If there's no simple way to do this, I think I found an example of what I
need in function printQuery in psql/print.c

Alex.

On Fri, 23 Feb 2001, adb wrote:

>
> Is there an easy way in libpq to get the results from
> any query as strings.
>
> Imagine a cgi where you input any query and then it prints
> out the rows returned
>
> Something like this example of mysql code:
>
> // fetch each row using mysql_fetch_row
>   MYSQL_ROW row;
>   unsigned int num_fields;
>
>   if( sql_result ) {
>     num_fields = mysql_num_fields( sql_result );
>
>     while( ( row = mysql_fetch_row( sql_result ) ) ) {
>
>       outputBuf_.print( L"<r>" );
>       for( unsigned int i = 0; i < num_fields ; i++ ) {
>         char * rowVal = row[i];
>         if( !rowVal ) {
>           rowVal = "";
>         }
>
>         outputBuf_.print( L"<c>%a</c>", rowVal );
>       }
>       outputBuf_.print( L"</r>\n" );
>     }
>   }
>
> Thanks,
>
> Alex.
>

> I want to set encoding hungarian language.
> I try to set LATIN2, but char order is "áabc..".
> The good order is "aábc...".
>
> What is the soultion?

configure PostgreSQL with --enable-locale option and rebuild it.
--
Tatsuo Ishii