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.