VB.NET NOT RECOGNIZING CHARACTER FROM SQL

0

Good morning everyone, I'm trying to download teradata information with a select statement, the problem is that when I do it in vb through code some of the characters in the result in the recordset contain accents and are not recognized, for example: ú, ü, û. This happens when I start reading the recordset in which they were stored.

Does anyone know how I can get these characters? since the specific reading of the field that contains it returns an empty field impossible to identify. I already tried to change my connection string to ASCII and utf8.

my code is as follows.

Public Function Connect_DSN5(ByVal Password As String) As Boolean
        Try
            Connection_String = "Data Source=DSN5; Database=DSN5; Persist Security Info=True; Session Mode=ANSI;"
            Pass = Password
            Connect()
            Return True
        Catch ex As Exception
            Return False
        End Try
    End Function

    Public Function Fill_Recordset(ByVal Query As String) As ADODB.Recordset
        Recordset1 = New ADODB.Recordset
        With Recordset1
            .CursorLocation = ADODB.CursorLocationEnum.adUseClient
            .Open(Query, Connection, ADODB.CursorTypeEnum.adOpenForwardOnly, ADODB.LockTypeEnum.adLockUnspecified)
        End With
        Return Recordset1
    End Function

Thank you very much, regards.

    
asked by MeProgramming 23.04.2018 в 18:25
source

0 answers