Hi! i’ve got a question regarding the C# driver. I’ve been trying to build an export tool for Cassandra based on your C# driver. I’m encountering an issue where, when tables have data with special characters, I dont receive these information within C#. Am I doing something wrong here, or is this a bug?
I’ve tried this on different environments (native cassandra on linux centos 7, docker setup on a windows vm). Both give the same result.
This is the data i put in cassandra:
t*\x10r>\nw@S=
This is what i get out:
t*x10r>nw@S=
Is there a way to get the backslashes as well?
EDIT: When I use the COPY command in cqlsh it does output the special characters.
[UPDATE] This is the method i use for fetching rows:
- public Task<RowSet> GetRowsAsync(ISession session, string table)
- {
- return session.ExecuteAsync(new SimpleStatement($"SELECT * FROM {table}"));
- }
This is the main code:
- _logger.Log("Fetching rows", fullTableName);
- var dataRows = await _cassandraService.GetRowsAsync(session, fullTableName);
- _logger.Log("Fetched rows", fullTableName);
-
- _logger.Log("Start writing data to CSV", fullTableName);
- TextWriter tw = new StreamWriter($"{_cassandraConfiguration.BackupTargetFolder}/{fullTableName}.csv");
- _counter.Reset();
- foreach (var dataRow in dataRows)
- {
- var stringRow = new string[dataRows.Columns.Length];
- for (int i = 0; i < dataRows.Columns.Length; i++)
- {
- var data = dataRow.GetValue<object>(dataRows.Columns[i].Name);
- if (data == null)
- {
- stringRow[i] = "";
- continue;
- }
-
- if (data is DateTimeOffset)
- stringRow[i] = ((DateTimeOffset)data).ToString("yyyy-MM-dd HH:mm:ss.fff+0000");
- else if (data is string)
- stringRow[i] = $"\"{data}\"";
- else
- stringRow[i] = data.ToString();
- }
- tw.WriteLine(string.Join(",", stringRow));
- _counter.IncrementCounter();
- }
-
- tw.Flush();
- tw.Close();
Let me know if something is unclear.
